﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<!-- saved from url=(0029)http://www.helpandmanual.com/ -->
<head>
   <title>Spotlight on Systems</title>
</head>
<body style="margin: 0px 0px 0px 0px; background: #FFFFFF;">
<div id="hmpopupDiv" style="visibility:hidden; position:absolute; z-index:1000; "></div>


<table width="100%" border="0" cellspacing="0" cellpadding="5" bgcolor="#649CCC">
  <tr valign="middle">
    <td align="left">
      <p class="p_Heading1"><span class="f_Heading1">Spotlight on Systems</span></p>
    </td>
  </tr>
</table>


<!-- Placeholder for topic body. -->
<table width="100%" border="0" cellspacing="0" cellpadding="5"><tr valign="top"><td align="left">
<p class="job_intro"><span class="job_intro">I have worked much of my life building and maintaining business systems as employee and consultant. To quickly summarize, I have built software systems on mainframes, minis, servers, and workstations using COBOL, BASIC, VB, C#, dot.NET, SQL, and a bunch of other databases and languages.  Click on job titles to see more detail.</span></p>

<p class="job_intro"><span class="job_intro">Although some of these jobs required Writing and Teaching, those duties are not shown here in this list, but are shown in Spotlight on Writing and Spotlight on Teaching. See also Spotlight on Tools to see specific levels of expertise. </span></p>

<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181A1_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181A1','$TOGGLE0181A1_ICON')">10/2010 - 03/2011 Consulting Analyst, Developer for Bennett Frozen Freight (for self); Jeffersonville, IN</a></span></p></td></tr></table></div><div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 4px 0px 0px 0px;"><table id="TOGGLE0181A1" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Upgraded hardware, operating systems, and software of server and workstations. Implemented data backup by synchronizing in cloud. Analyzed all office procedures. Restructured paper and data flows. Wrote program in Access 2010 to match electronic and cash receipts with Quickbooks billing and payroll. Researched, procured, and integrated scanned document management applications. Reduced effort to record, confirm, and approve events. Improved accuracy and timeliness of data. Eliminated redundant data entry. Instituted a system for scheduling duties, visible on calendars on websites. Used Server 2003, Windows 7, Google Apps, NAS, USB-3 attached storage, scanning stations, indexed file search.</span></p>
<p class="job_desc";><span class="job_desc"></span></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181A2_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181A2','$TOGGLE0181A2_ICON')">01/2010 - 01/2010 Consulting Analyst, Developer for Bennett Frozen Freight (for self); Jeffersonville, IN</a></span></p></td></tr></table></div><div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 4px 0px 0px 0px;"><table id="TOGGLE0181A2" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">For 3 weeks, fixed problems in LAN, domain, workstations, printers, scanners, shared directories. Installed packages and upgrades. Refined backup routines.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181A3_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181A3','$TOGGLE0181A3_ICON')">08/2008 - 09/2010 Instructor, ESL for NonHyeon High School; Incheon, Korea</a></span></p></td></tr></table></div><div><table id="TOGGLE0181A3" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Upgraded SmartBoard. Upgraded 5 computers to Win 7 Enterprise Hangul, Office 2010, Haansoft Hangul, etc. Synchronized files in cloud for lesson preparation from anywhere. Established websites for NonHyeon High School English Zone, English Program In Korea (EPIK).  Converted and analyzed 1500 word English learner's dictionary in MS Access using Range32 and concordancing, illustrated, by charts, words of inappropriate levels frustrating to students, pinpointed mistakes, and new version was much improved. Created spreadsheet workbooks tracking individual participation. Web charts improved engagement markedly. Programmed an animated game of Jeopardy in PowerPoint and VBA with touchscreen self-scoring of 2-7 teams, affording a raucous monthly review of lessons.</span></p>
<p><span style="font-size: 10pt; font-family: 'Calibri'; font-weight: bold; color: #000000;"></span></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181A4_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181A4','$TOGGLE0181A4_ICON')">04/2008 - 04/2008 Consulting Analyst, Developer for Bennett Frozen Freight (for self); Jeffersonville, IN</a></span></p></td></tr></table></div><div><table id="TOGGLE0181A4" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Renovated computers and LAN, added Windows Server 2003 domain name server. Advised selection of COTS software to replace aging Borland system with SaaS freight brokering. Cleaned and migrated 20+ tables of Interbase data into Access MDB for loading by the new provider.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181A5_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181A5','$TOGGLE0181A5_ICON')">07/2005 - 08/2006 Analyst/Programmer for San Mateo County Sheriff's Office; Redwood City, CA</a></span></p></td></tr></table></div><div><table id="TOGGLE0181A5" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Produced ASP.NET C# SQL Server intranet applications. Scrubbed and migrated data from MS Access, DBF to SQL Server. Ascertained from staff members how to extend functionality. Designed, programmed web-access apps that felt like desktop apps. For Security Section, built Case and Incidents tracking app, for Personnel Section, a DNA Samples Tracking System. Migrated data for the Background Investigations section. Setup versioning with Subversion.</span></p>
<p><span style="font-size: 10pt; font-family: 'Calibri'; font-weight: bold; color: #000000;"></span></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181A6_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181A6','$TOGGLE0181A6_ICON')">10/2004 - 10/2004 Consulting Analyst, Developer for Bennett Frozen Freight (for self); Jeffersonville, IN</a></span></p></td></tr></table></div><div><table id="TOGGLE0181A6" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">In 10 days, upgraded equipment and OS's for workstations and domain server. Upgraded A~Freight, other software packages.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181A7_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181A7','$TOGGLE0181A7_ICON')">09/2004 - 01/2005 Consulting Analyst, Developer for Nexxit, Inc. (for self); San Jose, CA</a></span></p></td></tr></table></div><div><table id="TOGGLE0181A7" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Experimented with emerging software methods like Xtreme Programming, Agile Development, UML design, QA practices, open source languages, versioning, issue tracking, QA/Testing.  Produced project proposals having scope of work, detailed schedules, deliverables and costing.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181A8_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181A8','$TOGGLE0181A8_ICON')">02/2003 - 08/2003 Consulting Project Manager, Analyst for San Mateo County Sheriff's Office (for NexxIT); Redwood City, CA</a></span></p></td></tr></table></div><div><table id="TOGGLE0181A8" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">On 6 month project migrating InterBase to SQL Server, implemented environment for top-notch software, and truly helpful documentation despite a staff of only 3. Negotiated standards, infrastructure, and project tools. Instituted Issue Tracking, QA/Regression Testing. Enforced versioning of code and documentation. Analyzed datebase and legacy code, Use Cases, Workflow. Created new database design, classes, functions, and confirmations of data migration. Managed activities in MS Project. Handled contract issues, technical tasks, client contact. Isolated functionality of legacy modules in Borland Delphi and Interbase using REGEX, GREP, and SQL. Facilitated resolutions of cross-department disputes with Use Case analysis. Wrote and illustrated all documentation, SQL queries and procedures. Wrote Crystal Reports having intricately mixed master-detail relationships, and several official documents generated automatically. This system tracked people given an alternative sentence by the courts through every contact, attendance, financial transaction and legal event. It had to be sophisticated enough to automate status transitions, alerts, and reviews, yet offered rapid input, forwarded data to other systems, and had extensive reporting. An intuitive user experience in a self-documenting system was a critical feature.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181A9_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181A9','$TOGGLE0181A9_ICON')">05/2000 - 02/2003 Product Architect, Manager for HyCube Technologies, Inc; San Ramon, CA</a></span></p></td></tr></table></div><div><table id="TOGGLE0181A9" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Obtained early sales for this startup with an analytic database engine, resituating internal architecture and external user experience to better serve less technical people. Directed development of interfaces suitable for the Data Warehouse market. Coordinated developers and beta clients in US, Korea, Russia, and France. Wrote and presented marketing materials to US, Korean and French venture capitalists and partners. Setup the development infrastructure; managed office sites, facilities, and systems. Built relationships for investment and co-development. Directed construction of a special regression-proofing application for the HyCube database engine.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181AA_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181AA','$TOGGLE0181AA_ICON')">11/1999 - 12/1999 Consulting Analyst, Developer for Bennett Frozen Freight (for self); Jeffersonville, IN</a></span></p></td></tr></table></div><div><table id="TOGGLE0181AA" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">For 3 weeks, remediated Y2K on equipment, software, and OS. Changed office practices, instalLed new equipment. Restructured InterBase database for speed.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181AB_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181AB','$TOGGLE0181AB_ICON')">09/1999 - 09/1999 Consulting Business Analyst for Hyundai Information Technology, USA (for self); San Jose, CA</a></span></p></td></tr></table></div><div><table id="TOGGLE0181AB" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">In 2 weeks, gathered industry data and expert knowledge with Korean counterparts, prepared, delivered marketing seminar about Enterprise Resource Planning with proposals for using SAP to consolidate national automotive distribution channels in the US.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181AC_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181AC','$TOGGLE0181AC_ICON')">05/1998 - 07/1999 Consulting Project Manager for Hyundai Information Technology, Inc.; Seoul, Korea</a></span></p></td></tr></table></div><div><table id="TOGGLE0181AC" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">For clients in Seoul, Toronto, New York, California, Incheon directed, participated in Y2K remediation projects. Co-developed marketing initiatives. Wrote collaterol for Y2K consulting market in US, Canada, and Korea. Led several projects in NY, Toronto, Seoul and Incheon. Tracked progress in MS Project; coordinated cross-teams; estimated workloads; resolved data and coding problems. Created MS Access tools for tracking remediation of program artifacts and physical equipment. At Hyundai Research Center, taught COBOL, directed semi-automated remediation of two million lines of COBOL. Setup a QA process tracking progress and issue resolutions. Directed remediation of 20 or so VBA Access database applications.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181AD_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181AD','$TOGGLE0181AD_ICON')">09/1996 - 12/1996 Consulting Analyst, Developer for Bennett Frozen Freight (for self); Jeffersonville, IN</a></span></p></td></tr></table></div><div><table id="TOGGLE0181AD" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Added features and reporting to Delphi InterBase A-Freight system:  Multi-Rig split Routing, Automatic Shipper Terms, Invoicing, Cost Allocations, and Settlement Management. Installed equipment.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181AE_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181AE','$TOGGLE0181AE_ICON')">02/1996 - 03/1996 Consulting Analyst for AIU (Malaysia for Trecom); Edison, NJ</a></span></p></td></tr></table></div><div><table id="TOGGLE0181AE" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">On 5 week contract in Kuala Lumpur coordinated US analysts and programmers, Hong Kong programmers, and Malaysian national insurance office. Created Access DB with input forms and reporting to manage inter-country report consolidation and conversion.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181AF_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181AF','$TOGGLE0181AF_ICON')">08/1995 - 04/1996 Consulting Analyst, Developer for Bennett Frozen Freight (for self); Jeffersonville, IN</a></span></p></td></tr></table></div><div><table id="TOGGLE0181AF" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Studied Object Oriented programming, built Windows applications using Borland Delphi and InterBase. Contracted and built a complex Client/Server system for freight brokering, and later, integrated business practices and systems to allow growth of fleet from three refrigerated semi-trailers and trucks to twelve.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181B0_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181B0','$TOGGLE0181B0_ICON')">05/1995 - 12/1995 Consulting Analyst, Developer for Bennett Frozen Freight (for self); Jeffersonville, IN</a></span></p></td></tr></table></div><div><table id="TOGGLE0181B0" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Designed, coded, implemented Windows application managing brokered and direct-contract freight hauling with load Routing and Dispatching, replicated Shipper Terms leg to leg, Invoicing.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181B1_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181B1','$TOGGLE0181B1_ICON')">02/1994 - 10/1994 Consulting Developer for Peerless Insurance (Keene NH for CTG); Buffalo, NY</a></span></p></td></tr></table></div><div><table id="TOGGLE0181B1" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Designed, coded a Rule-Based Insurance Rating system, gathering requirements from several lines of automobile insurance. Coded CICS and COBOL online, and batch programs, IDS-II databases and sequential files.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181B2_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181B2','$TOGGLE0181B2_ICON')">01/1992 - 01/1994 Consulting Project Lead, DBA for Pohang Steel (Korea for CTG and IBM); Buffalo, NY</a></span></p></td></tr></table></div><div><table id="TOGGLE0181B2" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Bridged cultural gaps in Pohang, adapting emerging tools locally, coaching best practices. As Lead Consultant reporting directly to the President of POSCO, led replacement of all business systems using CASE tool IEF and DB2, implementing 13 major systems, 2100 tables and 5000 application programs on time. Guided POSCO staff and 11 teams peaking at 250 developers. Persuaded company Directors and IT management to reform IT structure. Collaborated with TI consultants from Korea, the US, and England to integrate model versions, and protect and tune the IEF Encyclopedia database. Developed a suite of queries on the Repository database to identify team problems. Approved detailed modeling and design for all teams.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181B3_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181B3','$TOGGLE0181B3_ICON')">10/1991 - 01/1992 Consulting Developer, DBA for Vassar College (Poughkeepsie NY for CTG); Buffalo, NY</a></span></p></td></tr></table></div><div><table id="TOGGLE0181B3" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Tech Lead at Vassar College, built the Alumni Development system on time, using DB2 and IBM Cross System Product (CSP). Advised Vassar DBA on database design issues. Resolved severe contention problems impeding progress by scripting REXX batching and QA-version software installation routines.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181B4_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181B4','$TOGGLE0181B4_ICON')">08/1991 - 09/1991 Consulting Developer for GE Aerospace (Binghamton NY for CTG); Buffalo, NY</a></span></p></td></tr></table></div><div><table id="TOGGLE0181B4" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Built a system to extract, clean and rationalize source data from IDS-II databases, convert, encode, route to IBM-based financial system.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181B5_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181B5','$TOGGLE0181B5_ICON')">06/1989 - 08/1991 Consulting Developer, DBA for Avery (Framingham MA for CTG); Buffalo, NY</a></span></p></td></tr></table></div><div><table id="TOGGLE0181B5" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">For Avery, Inc., created transaction log-and-forward system in CICS/IDMS COBOL to synchronize cross-department data across mainframe sites. Enabled Avery to postpone significant hardware investment by restructuring core batch programs, cut nightly processing by 50% or more, reducing hardware memory requirements, execution times, trouble reports and batch program restarts. Restructured SQL queries and databases to gain similar reductions.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181B6_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181B6','$TOGGLE0181B6_ICON')">06/1987 - 02/1989 Database Administrator for GE Plastics; Pittsfield, MA</a></span></p></td></tr></table></div><div><table id="TOGGLE0181B6" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Maintained IDMS/R relational database system software. Controlled quality of development using analysis tools, direct inspection, monitoring, mandatory design reviews. Shared workload, off-hours coverage with two other DBA's, covering development efforts of over 150 developers.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181B7_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181B7','$TOGGLE0181B7_ICON')">02/1984 - 06/1987 Project Lead for GE Plastics; Pittsfield, MA</a></span></p></td></tr></table></div><div><table id="TOGGLE0181B7" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">For HQ and labs in Pittsfield, MA, and manufacturing centers in NY and Indiana, modified the Purchasing module of CAS, an emerging Enterprise Requirements Planning system, using IDMS-database and a 4th Generation Language. Directed a matrixed team of users, internal, and contract developers at three sites. Coordinated with Accounts Payable, General Ledger and Manufacturing. Mediated solutions with software publisher, contractors, and end users to overcome discrete product manufacturing designs not matching continuous process manufacturing of a plastics plant, convincing parties to institute change on their part. Became a go-to resource for reporting in Culprit. Implemented on time.</span></p>
<p></p>
</td>
</tr>
</table>
</div>
<div><table class="norm"><tr style="vertical-align:baseline" valign="baseline"><td width="18"><img id="$TOGGLE0181B8_ICON" src="http://description-toggler.googlecode.com/svn/trunk/hmtoggle_arrow1.gif" width="9" height="9" border="0" alt="hmtoggle_arrow1" title="click to toggle full description"></td><td><p class="job_title"><span class="job_title"><a class="dropdown-toggle" title="click to toggle full description" href="javascript:HMToggle('toggle','TOGGLE0181B8','$TOGGLE0181B8_ICON')">08/1978 - 02/1984 Analyst/Programmer for GE Medium Steam Turbine and Generator; Lynn, MA</a></span></p></td></tr></table></div><div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 4px 0px 0px 0px;"><table id="TOGGLE0181B8" cellspacing="0" cellpadding="0" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top"><p class="job_desc";><span class="job_desc">Customized Shop Floor Control and Inventory Management modules in Hewlett-Packard MM3000 MRP. Automated inventory movement with bar-coded data synchronized across HP and Honeywell platforms. Developed, maintained systems for engineering, warehousing, shipping, customer order placement, manufacturing. Led adoption of Structured Methods in Analysis, Design and Programming.</span></p>
<p></p>
</td>
</tr>
</table>
</div>

</td></tr></table>

</body>
</html>
